GET Reporting/v1/Stock/GetCompanyStockPeriodSummary?SiteIDs[0]={SiteIDs[0]}&SiteIDs[1]={SiteIDs[1]}&periodEndDate={periodEndDate}
Gets the Company Stock Period Summary report data for given sites and period date.
Request Information
URI Parameters
Name | Type | Description | Additional information |
---|---|---|---|
SiteIDs | Collection of integer |
Required: SiteIDs which the report will be run for |
|
periodEndDate | date |
Required: End Date on the requested Stock Period |
Body Parameters
None.
Response Information
Resource Description
Collection of CompanyStockPeriodSummaryReportItemDtoName | Type | Description | Additional information |
---|---|---|---|
SiteID | integer |
None. |
|
StockPeriodID | integer |
None. |
|
SiteName | string |
None. |
|
StartDateUtc | date |
None. |
|
EndDateUtc | date |
None. |
|
LocalTimeZoneID | string |
None. |
|
ProductTypeID | integer |
None. |
|
ProductType | string |
None. |
|
OpeningNetStockValue | decimal number |
None. |
|
ClosingNetStockValue | decimal number |
None. |
|
NetDeliverySubtotal | decimal number |
None. |
|
NetInboundSiteTransfers | decimal number |
None. |
|
NetOutboundSiteTransfers | decimal number |
None. |
|
NetConsumptionValue | decimal number |
None. |
|
RetailVarianceValue | decimal number |
None. |
|
NetSales | decimal number |
None. |
|
ExpNetSales | decimal number |
None. |
|
NetCostOfSales | decimal number |
None. |
|
NetCostOfWastage | decimal number |
None. |
|
NetCostOfAutoUsage | decimal number |
None. |
|
NetCreditSubtotal | decimal number |
None. |
|
NetStockVarianceValue | decimal number |
None. |
|
Rebate | decimal number |
None. |
|
EposNetSales | decimal number |
None. |
|
EposNetCostOfSales | decimal number |
None. |
|
PotentialSalesMargin | decimal number |
None. |
|
PotentialSalesGPPercentage | decimal number |
None. |
|
BeforeDiscountSalesMargin | decimal number |
None. |
|
BeforeDiscountSalesGPPercentage | decimal number |
None. |
|
AfterDiscountSalesMargin | decimal number |
None. |
|
AfterDiscountSalesGPPercentage | decimal number |
None. |
|
ActualSalesMargin | decimal number |
None. |
|
ActualSalesGPPercentage | decimal number |
None. |
|
CostOfSalesMargin | decimal number |
None. |
|
CostOfSalesGPPercentage | decimal number |
None. |
|
EposSalesMargin | decimal number |
None. |
|
NetCostOfGoods | decimal number |
None. |
|
CostOfGoodsEposSalesPercentage | decimal number |
None. |
|
StartDate | date |
None. |
|
EndDate | date |
None. |
Response Formats
application/json
Sample:
Sample not available.
text/json
Sample:
Sample not available.
application/xml, text/xml
Sample:
<ArrayOfCompanyStockPeriodSummaryReportItemDto xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Tevalis.StockMid.Core.Models.StockPeriods.Dto"> <CompanyStockPeriodSummaryReportItemDto> <_x003C_ClosingNetStockValue_x003E_k__BackingField>10</_x003C_ClosingNetStockValue_x003E_k__BackingField> <_x003C_EndDateUtc_x003E_k__BackingField>2024-11-21T06:26:26.1659654+00:00</_x003C_EndDateUtc_x003E_k__BackingField> <_x003C_EposNetCostOfSales_x003E_k__BackingField>25</_x003C_EposNetCostOfSales_x003E_k__BackingField> <_x003C_EposNetSales_x003E_k__BackingField>24</_x003C_EposNetSales_x003E_k__BackingField> <_x003C_ExpNetSales_x003E_k__BackingField>17</_x003C_ExpNetSales_x003E_k__BackingField> <_x003C_LocalTimeZoneID_x003E_k__BackingField>sample string 6</_x003C_LocalTimeZoneID_x003E_k__BackingField> <_x003C_NetConsumptionValue_x003E_k__BackingField>14</_x003C_NetConsumptionValue_x003E_k__BackingField> <_x003C_NetCostOfAutoUsage_x003E_k__BackingField>20</_x003C_NetCostOfAutoUsage_x003E_k__BackingField> <_x003C_NetCostOfSales_x003E_k__BackingField>18</_x003C_NetCostOfSales_x003E_k__BackingField> <_x003C_NetCostOfWastage_x003E_k__BackingField>19</_x003C_NetCostOfWastage_x003E_k__BackingField> <_x003C_NetCreditSubtotal_x003E_k__BackingField>21</_x003C_NetCreditSubtotal_x003E_k__BackingField> <_x003C_NetDeliverySubtotal_x003E_k__BackingField>11</_x003C_NetDeliverySubtotal_x003E_k__BackingField> <_x003C_NetInboundSiteTransfers_x003E_k__BackingField>12</_x003C_NetInboundSiteTransfers_x003E_k__BackingField> <_x003C_NetOutboundSiteTransfers_x003E_k__BackingField>13</_x003C_NetOutboundSiteTransfers_x003E_k__BackingField> <_x003C_NetSales_x003E_k__BackingField>16</_x003C_NetSales_x003E_k__BackingField> <_x003C_NetStockVarianceValue_x003E_k__BackingField>22</_x003C_NetStockVarianceValue_x003E_k__BackingField> <_x003C_OpeningNetStockValue_x003E_k__BackingField>9</_x003C_OpeningNetStockValue_x003E_k__BackingField> <_x003C_ProductTypeID_x003E_k__BackingField>7</_x003C_ProductTypeID_x003E_k__BackingField> <_x003C_ProductType_x003E_k__BackingField>sample string 8</_x003C_ProductType_x003E_k__BackingField> <_x003C_Rebate_x003E_k__BackingField>23</_x003C_Rebate_x003E_k__BackingField> <_x003C_RetailVarianceValue_x003E_k__BackingField>15</_x003C_RetailVarianceValue_x003E_k__BackingField> <_x003C_SiteID_x003E_k__BackingField>1</_x003C_SiteID_x003E_k__BackingField> <_x003C_SiteName_x003E_k__BackingField>sample string 3</_x003C_SiteName_x003E_k__BackingField> <_x003C_StartDateUtc_x003E_k__BackingField>2024-11-21T06:26:26.1659654+00:00</_x003C_StartDateUtc_x003E_k__BackingField> <_x003C_StockPeriodID_x003E_k__BackingField>2</_x003C_StockPeriodID_x003E_k__BackingField> </CompanyStockPeriodSummaryReportItemDto> <CompanyStockPeriodSummaryReportItemDto> <_x003C_ClosingNetStockValue_x003E_k__BackingField>10</_x003C_ClosingNetStockValue_x003E_k__BackingField> <_x003C_EndDateUtc_x003E_k__BackingField>2024-11-21T06:26:26.1659654+00:00</_x003C_EndDateUtc_x003E_k__BackingField> <_x003C_EposNetCostOfSales_x003E_k__BackingField>25</_x003C_EposNetCostOfSales_x003E_k__BackingField> <_x003C_EposNetSales_x003E_k__BackingField>24</_x003C_EposNetSales_x003E_k__BackingField> <_x003C_ExpNetSales_x003E_k__BackingField>17</_x003C_ExpNetSales_x003E_k__BackingField> <_x003C_LocalTimeZoneID_x003E_k__BackingField>sample string 6</_x003C_LocalTimeZoneID_x003E_k__BackingField> <_x003C_NetConsumptionValue_x003E_k__BackingField>14</_x003C_NetConsumptionValue_x003E_k__BackingField> <_x003C_NetCostOfAutoUsage_x003E_k__BackingField>20</_x003C_NetCostOfAutoUsage_x003E_k__BackingField> <_x003C_NetCostOfSales_x003E_k__BackingField>18</_x003C_NetCostOfSales_x003E_k__BackingField> <_x003C_NetCostOfWastage_x003E_k__BackingField>19</_x003C_NetCostOfWastage_x003E_k__BackingField> <_x003C_NetCreditSubtotal_x003E_k__BackingField>21</_x003C_NetCreditSubtotal_x003E_k__BackingField> <_x003C_NetDeliverySubtotal_x003E_k__BackingField>11</_x003C_NetDeliverySubtotal_x003E_k__BackingField> <_x003C_NetInboundSiteTransfers_x003E_k__BackingField>12</_x003C_NetInboundSiteTransfers_x003E_k__BackingField> <_x003C_NetOutboundSiteTransfers_x003E_k__BackingField>13</_x003C_NetOutboundSiteTransfers_x003E_k__BackingField> <_x003C_NetSales_x003E_k__BackingField>16</_x003C_NetSales_x003E_k__BackingField> <_x003C_NetStockVarianceValue_x003E_k__BackingField>22</_x003C_NetStockVarianceValue_x003E_k__BackingField> <_x003C_OpeningNetStockValue_x003E_k__BackingField>9</_x003C_OpeningNetStockValue_x003E_k__BackingField> <_x003C_ProductTypeID_x003E_k__BackingField>7</_x003C_ProductTypeID_x003E_k__BackingField> <_x003C_ProductType_x003E_k__BackingField>sample string 8</_x003C_ProductType_x003E_k__BackingField> <_x003C_Rebate_x003E_k__BackingField>23</_x003C_Rebate_x003E_k__BackingField> <_x003C_RetailVarianceValue_x003E_k__BackingField>15</_x003C_RetailVarianceValue_x003E_k__BackingField> <_x003C_SiteID_x003E_k__BackingField>1</_x003C_SiteID_x003E_k__BackingField> <_x003C_SiteName_x003E_k__BackingField>sample string 3</_x003C_SiteName_x003E_k__BackingField> <_x003C_StartDateUtc_x003E_k__BackingField>2024-11-21T06:26:26.1659654+00:00</_x003C_StartDateUtc_x003E_k__BackingField> <_x003C_StockPeriodID_x003E_k__BackingField>2</_x003C_StockPeriodID_x003E_k__BackingField> </CompanyStockPeriodSummaryReportItemDto> </ArrayOfCompanyStockPeriodSummaryReportItemDto>